package com.woniu.sale.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BsProviderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public BsProviderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProvideridIsNull() {
            addCriterion("providerID is null");
            return (Criteria) this;
        }

        public Criteria andProvideridIsNotNull() {
            addCriterion("providerID is not null");
            return (Criteria) this;
        }

        public Criteria andProvideridEqualTo(String value) {
            addCriterion("providerID =", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotEqualTo(String value) {
            addCriterion("providerID <>", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridGreaterThan(String value) {
            addCriterion("providerID >", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridGreaterThanOrEqualTo(String value) {
            addCriterion("providerID >=", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLessThan(String value) {
            addCriterion("providerID <", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLessThanOrEqualTo(String value) {
            addCriterion("providerID <=", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLike(String value) {
            addCriterion("providerID like", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotLike(String value) {
            addCriterion("providerID not like", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridIn(List<String> values) {
            addCriterion("providerID in", values, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotIn(List<String> values) {
            addCriterion("providerID not in", values, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridBetween(String value1, String value2) {
            addCriterion("providerID between", value1, value2, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotBetween(String value1, String value2) {
            addCriterion("providerID not between", value1, value2, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvidernameIsNull() {
            addCriterion("providerName is null");
            return (Criteria) this;
        }

        public Criteria andProvidernameIsNotNull() {
            addCriterion("providerName is not null");
            return (Criteria) this;
        }

        public Criteria andProvidernameEqualTo(String value) {
            addCriterion("providerName =", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameNotEqualTo(String value) {
            addCriterion("providerName <>", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameGreaterThan(String value) {
            addCriterion("providerName >", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameGreaterThanOrEqualTo(String value) {
            addCriterion("providerName >=", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameLessThan(String value) {
            addCriterion("providerName <", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameLessThanOrEqualTo(String value) {
            addCriterion("providerName <=", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameLike(String value) {
            addCriterion("providerName like", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameNotLike(String value) {
            addCriterion("providerName not like", value, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameIn(List<String> values) {
            addCriterion("providerName in", values, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameNotIn(List<String> values) {
            addCriterion("providerName not in", values, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameBetween(String value1, String value2) {
            addCriterion("providerName between", value1, value2, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidernameNotBetween(String value1, String value2) {
            addCriterion("providerName not between", value1, value2, "providername");
            return (Criteria) this;
        }

        public Criteria andProvidershortIsNull() {
            addCriterion("providerShort is null");
            return (Criteria) this;
        }

        public Criteria andProvidershortIsNotNull() {
            addCriterion("providerShort is not null");
            return (Criteria) this;
        }

        public Criteria andProvidershortEqualTo(String value) {
            addCriterion("providerShort =", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortNotEqualTo(String value) {
            addCriterion("providerShort <>", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortGreaterThan(String value) {
            addCriterion("providerShort >", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortGreaterThanOrEqualTo(String value) {
            addCriterion("providerShort >=", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortLessThan(String value) {
            addCriterion("providerShort <", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortLessThanOrEqualTo(String value) {
            addCriterion("providerShort <=", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortLike(String value) {
            addCriterion("providerShort like", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortNotLike(String value) {
            addCriterion("providerShort not like", value, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortIn(List<String> values) {
            addCriterion("providerShort in", values, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortNotIn(List<String> values) {
            addCriterion("providerShort not in", values, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortBetween(String value1, String value2) {
            addCriterion("providerShort between", value1, value2, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidershortNotBetween(String value1, String value2) {
            addCriterion("providerShort not between", value1, value2, "providershort");
            return (Criteria) this;
        }

        public Criteria andProvidertypeIsNull() {
            addCriterion("providerType is null");
            return (Criteria) this;
        }

        public Criteria andProvidertypeIsNotNull() {
            addCriterion("providerType is not null");
            return (Criteria) this;
        }

        public Criteria andProvidertypeEqualTo(String value) {
            addCriterion("providerType =", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeNotEqualTo(String value) {
            addCriterion("providerType <>", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeGreaterThan(String value) {
            addCriterion("providerType >", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeGreaterThanOrEqualTo(String value) {
            addCriterion("providerType >=", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeLessThan(String value) {
            addCriterion("providerType <", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeLessThanOrEqualTo(String value) {
            addCriterion("providerType <=", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeLike(String value) {
            addCriterion("providerType like", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeNotLike(String value) {
            addCriterion("providerType not like", value, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeIn(List<String> values) {
            addCriterion("providerType in", values, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeNotIn(List<String> values) {
            addCriterion("providerType not in", values, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeBetween(String value1, String value2) {
            addCriterion("providerType between", value1, value2, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvidertypeNotBetween(String value1, String value2) {
            addCriterion("providerType not between", value1, value2, "providertype");
            return (Criteria) this;
        }

        public Criteria andProvideraddressIsNull() {
            addCriterion("providerAddress is null");
            return (Criteria) this;
        }

        public Criteria andProvideraddressIsNotNull() {
            addCriterion("providerAddress is not null");
            return (Criteria) this;
        }

        public Criteria andProvideraddressEqualTo(String value) {
            addCriterion("providerAddress =", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressNotEqualTo(String value) {
            addCriterion("providerAddress <>", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressGreaterThan(String value) {
            addCriterion("providerAddress >", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressGreaterThanOrEqualTo(String value) {
            addCriterion("providerAddress >=", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressLessThan(String value) {
            addCriterion("providerAddress <", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressLessThanOrEqualTo(String value) {
            addCriterion("providerAddress <=", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressLike(String value) {
            addCriterion("providerAddress like", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressNotLike(String value) {
            addCriterion("providerAddress not like", value, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressIn(List<String> values) {
            addCriterion("providerAddress in", values, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressNotIn(List<String> values) {
            addCriterion("providerAddress not in", values, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressBetween(String value1, String value2) {
            addCriterion("providerAddress between", value1, value2, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andProvideraddressNotBetween(String value1, String value2) {
            addCriterion("providerAddress not between", value1, value2, "provideraddress");
            return (Criteria) this;
        }

        public Criteria andLinkmanIsNull() {
            addCriterion("linkman is null");
            return (Criteria) this;
        }

        public Criteria andLinkmanIsNotNull() {
            addCriterion("linkman is not null");
            return (Criteria) this;
        }

        public Criteria andLinkmanEqualTo(String value) {
            addCriterion("linkman =", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotEqualTo(String value) {
            addCriterion("linkman <>", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanGreaterThan(String value) {
            addCriterion("linkman >", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanGreaterThanOrEqualTo(String value) {
            addCriterion("linkman >=", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLessThan(String value) {
            addCriterion("linkman <", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLessThanOrEqualTo(String value) {
            addCriterion("linkman <=", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLike(String value) {
            addCriterion("linkman like", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotLike(String value) {
            addCriterion("linkman not like", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanIn(List<String> values) {
            addCriterion("linkman in", values, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotIn(List<String> values) {
            addCriterion("linkman not in", values, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanBetween(String value1, String value2) {
            addCriterion("linkman between", value1, value2, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotBetween(String value1, String value2) {
            addCriterion("linkman not between", value1, value2, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmantelIsNull() {
            addCriterion("linkmanTel is null");
            return (Criteria) this;
        }

        public Criteria andLinkmantelIsNotNull() {
            addCriterion("linkmanTel is not null");
            return (Criteria) this;
        }

        public Criteria andLinkmantelEqualTo(String value) {
            addCriterion("linkmanTel =", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelNotEqualTo(String value) {
            addCriterion("linkmanTel <>", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelGreaterThan(String value) {
            addCriterion("linkmanTel >", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelGreaterThanOrEqualTo(String value) {
            addCriterion("linkmanTel >=", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelLessThan(String value) {
            addCriterion("linkmanTel <", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelLessThanOrEqualTo(String value) {
            addCriterion("linkmanTel <=", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelLike(String value) {
            addCriterion("linkmanTel like", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelNotLike(String value) {
            addCriterion("linkmanTel not like", value, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelIn(List<String> values) {
            addCriterion("linkmanTel in", values, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelNotIn(List<String> values) {
            addCriterion("linkmanTel not in", values, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelBetween(String value1, String value2) {
            addCriterion("linkmanTel between", value1, value2, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andLinkmantelNotBetween(String value1, String value2) {
            addCriterion("linkmanTel not between", value1, value2, "linkmantel");
            return (Criteria) this;
        }

        public Criteria andProvidertelIsNull() {
            addCriterion("providerTel is null");
            return (Criteria) this;
        }

        public Criteria andProvidertelIsNotNull() {
            addCriterion("providerTel is not null");
            return (Criteria) this;
        }

        public Criteria andProvidertelEqualTo(String value) {
            addCriterion("providerTel =", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelNotEqualTo(String value) {
            addCriterion("providerTel <>", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelGreaterThan(String value) {
            addCriterion("providerTel >", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelGreaterThanOrEqualTo(String value) {
            addCriterion("providerTel >=", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelLessThan(String value) {
            addCriterion("providerTel <", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelLessThanOrEqualTo(String value) {
            addCriterion("providerTel <=", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelLike(String value) {
            addCriterion("providerTel like", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelNotLike(String value) {
            addCriterion("providerTel not like", value, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelIn(List<String> values) {
            addCriterion("providerTel in", values, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelNotIn(List<String> values) {
            addCriterion("providerTel not in", values, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelBetween(String value1, String value2) {
            addCriterion("providerTel between", value1, value2, "providertel");
            return (Criteria) this;
        }

        public Criteria andProvidertelNotBetween(String value1, String value2) {
            addCriterion("providerTel not between", value1, value2, "providertel");
            return (Criteria) this;
        }

        public Criteria andProviderfaxIsNull() {
            addCriterion("providerFax is null");
            return (Criteria) this;
        }

        public Criteria andProviderfaxIsNotNull() {
            addCriterion("providerFax is not null");
            return (Criteria) this;
        }

        public Criteria andProviderfaxEqualTo(String value) {
            addCriterion("providerFax =", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxNotEqualTo(String value) {
            addCriterion("providerFax <>", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxGreaterThan(String value) {
            addCriterion("providerFax >", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxGreaterThanOrEqualTo(String value) {
            addCriterion("providerFax >=", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxLessThan(String value) {
            addCriterion("providerFax <", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxLessThanOrEqualTo(String value) {
            addCriterion("providerFax <=", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxLike(String value) {
            addCriterion("providerFax like", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxNotLike(String value) {
            addCriterion("providerFax not like", value, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxIn(List<String> values) {
            addCriterion("providerFax in", values, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxNotIn(List<String> values) {
            addCriterion("providerFax not in", values, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxBetween(String value1, String value2) {
            addCriterion("providerFax between", value1, value2, "providerfax");
            return (Criteria) this;
        }

        public Criteria andProviderfaxNotBetween(String value1, String value2) {
            addCriterion("providerFax not between", value1, value2, "providerfax");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("postcode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("postcode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("postcode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("postcode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("postcode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("postcode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("postcode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("postcode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("postcode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("postcode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("postcode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("postcode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("postcode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("postcode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andAccountIsNull() {
            addCriterion("account is null");
            return (Criteria) this;
        }

        public Criteria andAccountIsNotNull() {
            addCriterion("account is not null");
            return (Criteria) this;
        }

        public Criteria andAccountEqualTo(String value) {
            addCriterion("account =", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotEqualTo(String value) {
            addCriterion("account <>", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThan(String value) {
            addCriterion("account >", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThanOrEqualTo(String value) {
            addCriterion("account >=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThan(String value) {
            addCriterion("account <", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThanOrEqualTo(String value) {
            addCriterion("account <=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLike(String value) {
            addCriterion("account like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotLike(String value) {
            addCriterion("account not like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountIn(List<String> values) {
            addCriterion("account in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotIn(List<String> values) {
            addCriterion("account not in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountBetween(String value1, String value2) {
            addCriterion("account between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotBetween(String value1, String value2) {
            addCriterion("account not between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andTaxnumIsNull() {
            addCriterion("taxnum is null");
            return (Criteria) this;
        }

        public Criteria andTaxnumIsNotNull() {
            addCriterion("taxnum is not null");
            return (Criteria) this;
        }

        public Criteria andTaxnumEqualTo(String value) {
            addCriterion("taxnum =", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumNotEqualTo(String value) {
            addCriterion("taxnum <>", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumGreaterThan(String value) {
            addCriterion("taxnum >", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumGreaterThanOrEqualTo(String value) {
            addCriterion("taxnum >=", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumLessThan(String value) {
            addCriterion("taxnum <", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumLessThanOrEqualTo(String value) {
            addCriterion("taxnum <=", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumLike(String value) {
            addCriterion("taxnum like", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumNotLike(String value) {
            addCriterion("taxnum not like", value, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumIn(List<String> values) {
            addCriterion("taxnum in", values, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumNotIn(List<String> values) {
            addCriterion("taxnum not in", values, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumBetween(String value1, String value2) {
            addCriterion("taxnum between", value1, value2, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTaxnumNotBetween(String value1, String value2) {
            addCriterion("taxnum not between", value1, value2, "taxnum");
            return (Criteria) this;
        }

        public Criteria andTrustmnyIsNull() {
            addCriterion("trustmny is null");
            return (Criteria) this;
        }

        public Criteria andTrustmnyIsNotNull() {
            addCriterion("trustmny is not null");
            return (Criteria) this;
        }

        public Criteria andTrustmnyEqualTo(BigDecimal value) {
            addCriterion("trustmny =", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyNotEqualTo(BigDecimal value) {
            addCriterion("trustmny <>", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyGreaterThan(BigDecimal value) {
            addCriterion("trustmny >", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("trustmny >=", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyLessThan(BigDecimal value) {
            addCriterion("trustmny <", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("trustmny <=", value, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyIn(List<BigDecimal> values) {
            addCriterion("trustmny in", values, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyNotIn(List<BigDecimal> values) {
            addCriterion("trustmny not in", values, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("trustmny between", value1, value2, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTrustmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("trustmny not between", value1, value2, "trustmny");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnIsNull() {
            addCriterion("transtatuskbn is null");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnIsNotNull() {
            addCriterion("transtatuskbn is not null");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnEqualTo(String value) {
            addCriterion("transtatuskbn =", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnNotEqualTo(String value) {
            addCriterion("transtatuskbn <>", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnGreaterThan(String value) {
            addCriterion("transtatuskbn >", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnGreaterThanOrEqualTo(String value) {
            addCriterion("transtatuskbn >=", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnLessThan(String value) {
            addCriterion("transtatuskbn <", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnLessThanOrEqualTo(String value) {
            addCriterion("transtatuskbn <=", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnLike(String value) {
            addCriterion("transtatuskbn like", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnNotLike(String value) {
            addCriterion("transtatuskbn not like", value, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnIn(List<String> values) {
            addCriterion("transtatuskbn in", values, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnNotIn(List<String> values) {
            addCriterion("transtatuskbn not in", values, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnBetween(String value1, String value2) {
            addCriterion("transtatuskbn between", value1, value2, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andTranstatuskbnNotBetween(String value1, String value2) {
            addCriterion("transtatuskbn not between", value1, value2, "transtatuskbn");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisIsNull() {
            addCriterion("venderrtndis is null");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisIsNotNull() {
            addCriterion("venderrtndis is not null");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisEqualTo(String value) {
            addCriterion("venderrtndis =", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisNotEqualTo(String value) {
            addCriterion("venderrtndis <>", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisGreaterThan(String value) {
            addCriterion("venderrtndis >", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisGreaterThanOrEqualTo(String value) {
            addCriterion("venderrtndis >=", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisLessThan(String value) {
            addCriterion("venderrtndis <", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisLessThanOrEqualTo(String value) {
            addCriterion("venderrtndis <=", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisLike(String value) {
            addCriterion("venderrtndis like", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisNotLike(String value) {
            addCriterion("venderrtndis not like", value, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisIn(List<String> values) {
            addCriterion("venderrtndis in", values, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisNotIn(List<String> values) {
            addCriterion("venderrtndis not in", values, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisBetween(String value1, String value2) {
            addCriterion("venderrtndis between", value1, value2, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andVenderrtndisNotBetween(String value1, String value2) {
            addCriterion("venderrtndis not between", value1, value2, "venderrtndis");
            return (Criteria) this;
        }

        public Criteria andSecondflgIsNull() {
            addCriterion("secondFlg is null");
            return (Criteria) this;
        }

        public Criteria andSecondflgIsNotNull() {
            addCriterion("secondFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSecondflgEqualTo(String value) {
            addCriterion("secondFlg =", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgNotEqualTo(String value) {
            addCriterion("secondFlg <>", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgGreaterThan(String value) {
            addCriterion("secondFlg >", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgGreaterThanOrEqualTo(String value) {
            addCriterion("secondFlg >=", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgLessThan(String value) {
            addCriterion("secondFlg <", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgLessThanOrEqualTo(String value) {
            addCriterion("secondFlg <=", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgLike(String value) {
            addCriterion("secondFlg like", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgNotLike(String value) {
            addCriterion("secondFlg not like", value, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgIn(List<String> values) {
            addCriterion("secondFlg in", values, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgNotIn(List<String> values) {
            addCriterion("secondFlg not in", values, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgBetween(String value1, String value2) {
            addCriterion("secondFlg between", value1, value2, "secondflg");
            return (Criteria) this;
        }

        public Criteria andSecondflgNotBetween(String value1, String value2) {
            addCriterion("secondFlg not between", value1, value2, "secondflg");
            return (Criteria) this;
        }

        public Criteria andProviderwwwIsNull() {
            addCriterion("providerWWW is null");
            return (Criteria) this;
        }

        public Criteria andProviderwwwIsNotNull() {
            addCriterion("providerWWW is not null");
            return (Criteria) this;
        }

        public Criteria andProviderwwwEqualTo(String value) {
            addCriterion("providerWWW =", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwNotEqualTo(String value) {
            addCriterion("providerWWW <>", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwGreaterThan(String value) {
            addCriterion("providerWWW >", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwGreaterThanOrEqualTo(String value) {
            addCriterion("providerWWW >=", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwLessThan(String value) {
            addCriterion("providerWWW <", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwLessThanOrEqualTo(String value) {
            addCriterion("providerWWW <=", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwLike(String value) {
            addCriterion("providerWWW like", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwNotLike(String value) {
            addCriterion("providerWWW not like", value, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwIn(List<String> values) {
            addCriterion("providerWWW in", values, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwNotIn(List<String> values) {
            addCriterion("providerWWW not in", values, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwBetween(String value1, String value2) {
            addCriterion("providerWWW between", value1, value2, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderwwwNotBetween(String value1, String value2) {
            addCriterion("providerWWW not between", value1, value2, "providerwww");
            return (Criteria) this;
        }

        public Criteria andProviderintroIsNull() {
            addCriterion("providerIntro is null");
            return (Criteria) this;
        }

        public Criteria andProviderintroIsNotNull() {
            addCriterion("providerIntro is not null");
            return (Criteria) this;
        }

        public Criteria andProviderintroEqualTo(String value) {
            addCriterion("providerIntro =", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroNotEqualTo(String value) {
            addCriterion("providerIntro <>", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroGreaterThan(String value) {
            addCriterion("providerIntro >", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroGreaterThanOrEqualTo(String value) {
            addCriterion("providerIntro >=", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroLessThan(String value) {
            addCriterion("providerIntro <", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroLessThanOrEqualTo(String value) {
            addCriterion("providerIntro <=", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroLike(String value) {
            addCriterion("providerIntro like", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroNotLike(String value) {
            addCriterion("providerIntro not like", value, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroIn(List<String> values) {
            addCriterion("providerIntro in", values, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroNotIn(List<String> values) {
            addCriterion("providerIntro not in", values, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroBetween(String value1, String value2) {
            addCriterion("providerIntro between", value1, value2, "providerintro");
            return (Criteria) this;
        }

        public Criteria andProviderintroNotBetween(String value1, String value2) {
            addCriterion("providerIntro not between", value1, value2, "providerintro");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNull() {
            addCriterion("updateDate is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNotNull() {
            addCriterion("updateDate is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateEqualTo(Date value) {
            addCriterion("updateDate =", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotEqualTo(Date value) {
            addCriterion("updateDate <>", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThan(Date value) {
            addCriterion("updateDate >", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("updateDate >=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThan(Date value) {
            addCriterion("updateDate <", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThanOrEqualTo(Date value) {
            addCriterion("updateDate <=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIn(List<Date> values) {
            addCriterion("updateDate in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotIn(List<Date> values) {
            addCriterion("updateDate not in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateBetween(Date value1, Date value2) {
            addCriterion("updateDate between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotBetween(Date value1, Date value2) {
            addCriterion("updateDate not between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNull() {
            addCriterion("updateMan is null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNotNull() {
            addCriterion("updateMan is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanEqualTo(String value) {
            addCriterion("updateMan =", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotEqualTo(String value) {
            addCriterion("updateMan <>", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThan(String value) {
            addCriterion("updateMan >", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThanOrEqualTo(String value) {
            addCriterion("updateMan >=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThan(String value) {
            addCriterion("updateMan <", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThanOrEqualTo(String value) {
            addCriterion("updateMan <=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLike(String value) {
            addCriterion("updateMan like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotLike(String value) {
            addCriterion("updateMan not like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIn(List<String> values) {
            addCriterion("updateMan in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotIn(List<String> values) {
            addCriterion("updateMan not in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanBetween(String value1, String value2) {
            addCriterion("updateMan between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotBetween(String value1, String value2) {
            addCriterion("updateMan not between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("`status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("`status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("`status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("`status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("`status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("`status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("`status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("`status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("`status` like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("`status` not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("`status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("`status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("`status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("`status` not between", value1, value2, "status");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}